/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-07-16 08:11:08
*/


-- ----------------------------
-- Table structure for tb0102
-- ----------------------------
DROP TABLE [dbo].[tb0102]
GO
CREATE TABLE [dbo].[tb0102] (
[OrderID] varchar(20) NOT NULL ,
[DivisionID] varchar(20) NOT NULL ,
[TranMonth] int NOT NULL ,
[TranYear] int NOT NULL ,
[OrderDate] datetime NULL ,
[OrderNo] varchar(20) NULL ,
[QuotationID] varchar(20) NULL ,
[CustomerID] varchar(20) NULL ,
[ProjectID] varchar(20) NULL ,
[ContractNo] varchar(20) NULL ,
[ContractDate] datetime NULL ,
[Content] varchar(100) NULL ,
[TotalAmount] money NULL ,
[CurrencyID] varchar(20) NULL ,
[TotalQuantity] money NULL ,
[PaymentID] varchar(20) NULL ,
[Notes] varchar(100) NULL ,
[Status] tinyint NOT NULL DEFAULT ((0)) ,
[IsPicking] tinyint NOT NULL DEFAULT ((0)) ,
[WareHouseID] varchar(20) NULL ,
[CreateUserID] varchar(20) NULL ,
[CreateDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL 
)


GO

-- ----------------------------
-- Records of tb0102
-- ----------------------------

-- ----------------------------
-- Indexes structure for table tb0102
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0102
-- ----------------------------
ALTER TABLE [dbo].[tb0102] ADD PRIMARY KEY NONCLUSTERED ([OrderID])
GO
